﻿/********************************************************************************************************************
* Author:	Aristidis Mihail																						 *
* Email:	std03055@di.uoa.gr																						 *
* Purpose:	This script is used in order to create the stored procedure "usp_category_delete_moderator" that deletes *		
*			a moderator from a category.																			*																		 *
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_category_delete_moderator]
	@userid bigint,
	@categoryID bigint
AS

	DELETE FROM [Category-Moderator]
	WHERE Category=@categoryID AND Moderator=@userid

RETURN 0